Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012
My Training Academy
Summary
Pay in full or spread the cost evenly with 3 or 6 Easy Monthly Payments (Interest free option – No ...
- Certificate of completion - Free
Add to basket or enquire
Overview
Please note that Microsoft have retired this exam. Although the exam(s) associated with this course has been retired by Microsoft, this course still retains value as a training resource & learners will receive a certificate of completion after completing the course.
This course prepares students for the 70-466: Implementing Data Models and Reports with SQL Server 2012 exam. The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining.
Description
- 12 months unlimited access
- Certificate of completion awarded upon completing the course to show to employers or prospective employers your new skills
- Free upgrade on to our premium platform
- Free career advice available upon request after completing the course
Today’s IT Industry demands that professionals cover the latest technology on the marketplace. Many IT professionals separate themselves from their competitors by achieving certifications in the most current technologies and giving themselves skill-sets that are unmatched by many of their peers.
This course has been designed to prepare you for the Microsoft 70-466 exam. The exam covers the following topics:
- Build an analysis services multidimensional database.
- Manage, maintain and troubleshoot an SQL Server Analysis Services (SSAS) database.
- Build a tabular data model.
- Build a report with SQL Server Reporting Services (SSRS).
This course prepares students for the 70-466: Implementing Data Models and Reports with SQL Server 2012 exam. The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining.
Module Breakdown
Module 1: Introduction to Business Intelligence and Data Modelling
- 1.1 Introduction to Business Intelligence and Data Modelling Part 1
- 1.2 Introduction to Business Intelligence and Data Modelling Part 2
- 1.3 The Microsoft Business Intelligence Platform Part 1
- 1.4 The Microsoft Business Intelligence Platform Part 2
- 1.5 The Microsoft Business Intelligence Platform Part 3
- 1.6 The Microsoft Business Intelligence Platform Part 4
Module 2: Implementing Reports the SQL Server Reporting Services
- 2.1 Implementing Reports the SQL Server Reporting Services Part 1
- 2.2 Implementing Reports the SQL Server Reporting Services Part 2
- 2.3 Implementing Reports the SQL Server Reporting Services Part 3
- 2.4 Implementing Reports the SQL Server Reporting Services Part 4
- 2.5 Implementing Reports the SQL Server Reporting Services Part 5
- 2.6 Implementing Reports the SQL Server Reporting Services Part 6
- 2.7 Implementing Reports the SQL Server Reporting Services Part 7
- 2.8 Implementing Reports the SQL Server Reporting Services Part 8
Module 3: Supporting Self Service Reporting
- 3.1 Supporting Self Service Reporting Part 1
- 3.2 Supporting Self Service Reporting Part 2
Module 4: Managing Report Execution and Delivery
- 4.1 Managing Report Execution and Delivery
- 4.2 Managing Report Execution
- 4.3 Subscriptions and Data Alerts
Module 5: Creating Multidimensional Databases
- 5.1 Creating Multidimensional Databases
- 5.2 Creating Data Sources and Data Source Views
- 5.3 Creating and Browsing a Cube
Module 6: Working with Cubes and Dimensions
- 6.1 Working with Cubes and Dimensions
- 6.2 Sorting and Grouping Attributes
Module 7: Working with Measures and Measure Groups
- 7.1 Working with Measures and Measure Groups
Module 8: Introduction to MDX
- 8.1 Introduction to MDX
- 8.2 Adding Calculations to a Cube
Module 9: Customizing Cube Functionality
- 9.1 Customizing Cube Functionality Part 1
- 9.2 Customizing Cube Functionality Part 2
- 9.3 Customizing Cube Functionality Part 3
Module 10: Implementing a Tabular Data Model
- 10.1 Implementing a Tabular Data Model Part 1
- 10.2 Implementing a Tabular Data Model Part 2
Module 11: Introduction to DAX
- 11.1 Introduction to DAX
- 11.2 Demonstration Making a Tabular Model Part 1
- 11.3 Demonstration Making a Tabular Model Part 2
- 11.4 Using DAX
Module 12: Implementing an Analysis Services Tabular Data Model
- 12.1 Implementing an Analysis Services Tabular Data Model Part 1
- 12.2 Implementing an Analysis Services Tabular Data Model Part 2
- 12.3 Deploying a Tabular Data Model
Module 13: SQL Analysis Services
- 13.1 SQL Analysis Services Part 1
- 13.2 SQL Analysis Services Part 2
Module 14: Creating Data Visualizations with Power View
- 14.1 Creating Data Visualizations with Power View
Module 15: Supporting Self Service Reporting
- 15.1 Supporting Self Service Reporting
Module 16: Performing Predictive Analysis with Data Mining
- 16.1 Performing Predictive Analysis with Data Mining
- 16.2 Using the Data Mining Wizard
Module 17: Predictive Analytics
- 17.1 Predictive Analytics Part 1
- 17.2 Predictive Analytics Part 2
Why My Training Academy? My Training Academy’s training courses are light-years ahead of our competitors. We provide expert instructor-led training modules with customised presentations, practice exam simulators and learning supplements that provide the full benefits of live classroom training – you can study when and where you want, at your own pace.
Benefit? Our online courses are delivered by the industry’s finest instructors, with a minimum of 15 years real world experience and experts in their fields. You will learn all the relevant skills to support you in attaining your dream job. Gain the skills in demand by employers and the confidence that you’re one step closer to your dream job, promotion or new career.
Why not try the training for free? Request a free demo today at no extra cost.
Invest in yourself: Acquiring these vital business skills – will repay the cost in improved employment opportunities and job satisfaction. What better investment than in your own future? The sooner you start, the sooner you will benefit.
When can I start? Enquire today, simply enrol and you can start studying today if you wish.
What are our students saying about us? I have just bought the Networking Bundle from My Training Academy and can't wait to get started! The service received from John was first class, He gave me a fantastic price on the bundle which I really appreciated having recently been made redundant. Really helpful to have a free demo to see the course before buying. Really like this style of training it will suit me down to the ground, can’t thank you enough.
Questions and answers
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.